The Tetris-Algorithm for Sorted Reading from UB-Tree

نویسنده

  • Volker Markl
چکیده

1.1 Addresses, Areas and Regions We iteratively define an area A as a special subspace of a d-dimensional cube as follows: Split the cube with respect to every dimension in the middle, resulting in 2 subcubes numbered in some arbitrary but fixed order (for our implementation and this paper we used Z-ordering) from 1 to 2. An area A1 of level 1 consists of the first i1 closed subcubes. i1 determines A1 uniquely. We call i1 the address of A1 and write A1 = area(i1). The empty area has the address ε. To enlarge an area, we iteratively add an area with address i2 ∈{0,1,...,2-1} of the next subcube with number i1+1. The address of this enlarged area A2 is i1.i2, which is lexicographically larger than the address i1 of area A1. Next we may enlarge A2 by adding an area of the brother subcube i2+1 of i2, etc. The left part of figure 1 shows four areas area(0.0.1), area(1.3.2), area(2.1) and area(3) of a twodimensional universe. The shaded subcubes of the two-dimensional universe belong to the corresponding area.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Efficient Processing of the Cube Operator

This paper presents a part of the doctoral work with the theme: “The impact of sorted reading from UB-trees on relational database systems”. Based on [Mar99] this doctoral work deals with the problems of the efficient implementation and analysis of sorted reading (UB-Cache [Bay97b], Tetris -Algorithm [MB98], [MZB99]) and its effect on query-processing and query optimization in relational databa...

متن کامل

The UB - Tree : Performance of Multidimensional Range Queries

We investigate the usability and performance of the UB-Tree (universal B-Tree) for multidimensional data, as they arise in all relational databases and in particular in datawarehousing and data-mining applications. The UB-Tree is balanced and has all the guaranteed performance characteristics of B-Trees, i.e., it requires linear space for storage and logarithmic time for the basic operations of...

متن کامل

The UB - Tree : Performance of Multidimensional Range

We investigate the usability and performance of the UB-Tree (universal B-Tree) for multidimensional data, as they arise in all relational databases and in particular in datawarehousing and data-mining applications. The UB-Tree is balanced and has all the guaranteed performance characteristics of B-Trees, i.e., it requires linear space for storage and logarithmic time for the basic operations of...

متن کامل

Processing Operations with Restrictions in RDBMS without External Sorting: The Tetris Algorithm

Most operations of the relational algebra or SQL require a sorted stream of tuples for efficient processing. Therefore, processing complex relational queries relies on efficient access to a table in some sort order. In principle, indexes could be used, but they are superior to a full table scan only, if the result set is sufficiently restricted in the index attribute. In this paper we present t...

متن کامل

Exploitation of Pre-sortedness for Sorting in Query Processing: The TempTris-Algorithm for UB-Trees

Bulk loading is used to efficiently build a table or access structure, if a large data set is available at index creation time, e.g., the spool process of a data warehouse or the creation of intermediate results during query processing. In this paper we introduce the TempTris algorithm that creates a multidimensional partitioning from a one-dimensionally sorted stream of tuples. In order to ach...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1998